[dbo].[IMISTable]

SQLServer > iMIS1521GA > Tables > dbo.IMISTable

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Created	10:31:25 AM Tuesday, March 02, 2010
Last Modified	11:40:03 AM Monday, February 20, 2012

Columns

Name	Data Type	Max Length (Bytes)	Default
IMISTableName	nvarchar(128)	256
IsIMIS10Table	bit	1	((0))
IsIMIS15Table	bit	1	((0))

Indexes

	Name	Columns	Unique
	PK_IMISTable	IMISTableName

SQL Script

CREATE TABLE [dbo].[IMISTable]
(
[IMISTableName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsIMIS10Table] [bit] NOT NULL CONSTRAINT [DF_IMISTable_IsIMIS10Table] DEFAULT ((0)),
[IsIMIS15Table] [bit] NOT NULL CONSTRAINT [DF_IMISTable_IsMIS15Table] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[IMISTable] ADD CONSTRAINT [PK_IMISTable] PRIMARY KEY CLUSTERED ([IMISTableName]) ON [PRIMARY]
GO

Uses